﻿<Template Name="MSOIndividual_New">
  <ConfigurableComponent ComponentName="MetadataConnectionString" ComponentClassId="{48BC612F-4042-48B2-8191-22D7FB9437DF}" ComponentUri="Package=Load_MSOIndividualProfile/Variable=MetadataConnectionString" ComponentType="Variable" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="Value" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="PartialStagingSQLStatement" ComponentClassId="{9DA42A22-629E-4700-A4EF-210F951086CE}" ComponentUri="Package=Load_MSOIndividualProfile/Variable=PartialStagingSQLStatement" ComponentType="Variable" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="Value" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="PubConnectionString" ComponentClassId="{7D0D7907-5389-4ED6-876E-2A033C8E0214}" ComponentUri="Package=Load_MSOIndividualProfile/Variable=PubConnectionString" ComponentType="Variable" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="Value" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="SourceConnectionString" ComponentClassId="{E0978EAD-DB9E-4C23-A0DB-1235DCB1EAFF}" ComponentUri="Package=Load_MSOIndividualProfile/Variable=SourceConnectionString" ComponentType="Variable" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="Value" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="SourceQuery" ComponentClassId="{436A4D36-0B5D-4CB8-96B7-9C479616F995}" ComponentUri="Package=Load_MSOIndividualProfile/Variable=SourceQuery" ComponentType="Variable" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="Value" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="StagingConnectionString" ComponentClassId="{E72AC387-C25D-4FEB-9549-D8EB45C3AC46}" ComponentUri="Package=Load_MSOIndividualProfile/Variable=StagingConnectionString" ComponentType="Variable" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="Value" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="StagingSQLStatement" ComponentClassId="{055B7349-8C5F-4784-9519-9742D6138AF5}" ComponentUri="Package=Load_MSOIndividualProfile/Variable=StagingSQLStatement" ComponentType="Variable" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="Value" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="TableName" ComponentClassId="{5952F848-0279-44C3-8676-48CE8C969E66}" ComponentUri="Package=Load_MSOIndividualProfile/Variable=TableName" ComponentType="Variable" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="Value" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="WorkAreaConnectionString" ComponentClassId="{40F6BE4B-2FAE-4932-8DD8-D37079D1D929}" ComponentUri="Package=Load_MSOIndividualProfile/Variable=WorkAreaConnectionString" ComponentType="Variable" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="Value" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="ETLWorkArea" ComponentClassId="{3d9fdd33-d0fa-4e84-bc5a-ba4a8e32cc75}" ComponentUri="Package=Load_MSOIndividualProfile/Connection=ETLWorkArea" ComponentType="ConnectionManager" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="ConnectionString" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="MetadataConnectionString" ComponentClassId="{AD11D864-E5E9-4F6E-9323-4A1FCE3801D1}" ComponentUri="Package=Load_MSOIndividualProfile/Connection=MetadataConnectionString" ComponentType="ConnectionManager" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="ConnectionString" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="PubConnectionString" ComponentClassId="{751B8CA8-E376-428E-9A7B-3F50649586DC}" ComponentUri="Package=Load_MSOIndividualProfile/Connection=PubConnectionString" ComponentType="ConnectionManager" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="ConnectionString" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="SourceConnectionString" ComponentClassId="{B7608C9C-2DCC-4F0C-B10F-1E556BF9A5D6}" ComponentUri="Package=Load_MSOIndividualProfile/Connection=SourceConnectionString" ComponentType="ConnectionManager" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="ConnectionString" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="StagingConnectionString" ComponentClassId="{308D70C7-8625-4711-AD6C-8CAB40B431E8}" ComponentUri="Package=Load_MSOIndividualProfile/Connection=StagingConnectionString" ComponentType="ConnectionManager" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="ConnectionString" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="Get Source query from meta" ComponentClassId="{46D71931-DCAE-497B-9F31-532EC6F91965}" ComponentUri="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Get Source query from meta" ComponentType="Executable" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="SqlStatementSource" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="Truncate Staging Table" ComponentClassId="{29f3ccb0-de44-4f5d-8070-8d0e38300cfd}" ComponentUri="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Truncate Tables/Executable=Truncate Staging Table" ComponentType="Executable" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="SqlStatementSource" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="Truncate GenevaOne Table" ComponentClassId="{92641f07-b399-40e0-badc-0a85ac3d3de6}" ComponentUri="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Truncate Tables/Executable=Truncate GenevaOne Table" ComponentType="Executable" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="SqlStatementSource" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="Truncate Workarea" ComponentClassId="{E00EE60E-56C1-4CA6-AE7F-A25F61EA4BED}" ComponentUri="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Truncate Workarea/Executable=Truncate Workarea" ComponentType="Executable" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="SqlStatementSource" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="Staging" ComponentClassId="{E2568105-9550-4F71-A638-B7FE42E66922}" ComponentUri="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Full Extract/Executable=Source to Staging/Component=Staging" ComponentType="Component" RowsetType="" ContainsMappings="True" ContainsCollections="False">
    <ConfigurableProperty Name="OpenRowset" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="GenevaOne" ComponentClassId="{E2568105-9550-4F71-A638-B7FE42E66922}" ComponentUri="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Full Extract/Executable=Staging to GenevaOne (Full)/Component=GenevaOne" ComponentType="Component" RowsetType="" ContainsMappings="True" ContainsCollections="False">
    <ConfigurableProperty Name="OpenRowset" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="Workarea" ComponentClassId="{E2568105-9550-4F71-A638-B7FE42E66922}" ComponentUri="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Source to Workarea/Component=Workarea" ComponentType="Component" RowsetType="" ContainsMappings="True" ContainsCollections="False">
    <ConfigurableProperty Name="OpenRowset" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="Fetch Delta from WorkArea" ComponentClassId="{2C0A8BE5-1EDC-4353-A0EF-B778599C65A0}" ComponentUri="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=WorkArea to Staging/Component=Fetch Delta from WorkArea" ComponentType="Component" RowsetType="" ContainsMappings="False" ContainsCollections="False">
    <ConfigurableProperty Name="SqlCommand" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="ExtractionID Clone" ComponentClassId="{9CF90BF0-5BCC-4C63-B91D-1F322DC12C26}" ComponentUri="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=WorkArea to Staging/Component=ExtractionID Clone" ComponentType="Component" RowsetType="" ContainsMappings="False" ContainsCollections="True" />
  <ConfigurableComponent ComponentName="OLE DB Destination" ComponentClassId="{E2568105-9550-4F71-A638-B7FE42E66922}" ComponentUri="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=WorkArea to Staging/Component=OLE DB Destination" ComponentType="Component" RowsetType="" ContainsMappings="True" ContainsCollections="False">
    <ConfigurableProperty Name="OpenRowset" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="Staging Command" ComponentClassId="{C60ACAD1-9BE8-46B3-87DA-70E59EADEA46}" ComponentUri="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=WorkArea to Staging/Component=Staging Command" ComponentType="Component" RowsetType="" ContainsMappings="True" ContainsCollections="False">
    <ConfigurableProperty Name="SqlCommand" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="Lookup" ComponentClassId="{0FB4AABB-C027-4440-809A-1198049BF117}" ComponentUri="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Staging to GenevaOne(Delta)/Component=Lookup" ComponentType="Component" RowsetType="" ContainsMappings="False" ContainsCollections="True">
    <ConfigurableProperty Name="SqlCommand" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="OLE DB Destination" ComponentClassId="{E2568105-9550-4F71-A638-B7FE42E66922}" ComponentUri="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Staging to GenevaOne(Delta)/Component=OLE DB Destination" ComponentType="Component" RowsetType="" ContainsMappings="True" ContainsCollections="False">
    <ConfigurableProperty Name="OpenRowset" />
  </ConfigurableComponent>
  <ConfigurableComponent ComponentName="Pub Command" ComponentClassId="{C60ACAD1-9BE8-46B3-87DA-70E59EADEA46}" ComponentUri="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Staging to GenevaOne(Delta)/Component=Pub Command" ComponentType="Component" RowsetType="" ContainsMappings="True" ContainsCollections="False">
    <ConfigurableProperty Name="SqlCommand" />
  </ConfigurableComponent>
</Template>